Release 10.1A: OpenEdge Data Management:
Database Administration

Lock Requests by User

Displays information about lock requests, organized by user. Figure 19–46 shows a sample Lock Requests by User display.

09/25/03        Lock Requests by User 16:19 Usr   User   --- Record ---   ---- Trans ---    ---- Schema --- Num   Name   Locks    Waits   Locks    Waits    Locks     Waits   0   SYSTEM     0        0       0        0        0         0   5   rgw        0        0       0        0        0         0   6              0        0       0        0        0         0   7           3625        0       0        0        0         0

Figure 19–46: PROMON Lock Requests by User display

This display shows the following information:

Usr Num — The user number.
User Name — The user name.
Record Locks — The number of records locks acquired by the user.
Record Waits — The number of times the user had to wait for a record lock.
Trans Locks — Not currently implemented.
Trans Waits — The number of times the user had to wait for a record lock.
Schema Locks — The number of schema locks acquired by the user.
Schema Waits — The number of times the user had to wait for a schema lock.